Task
Populate the P&L statement format you created by extracting the necessary source data from the raw Bloomberg files. Use the INDEX, MATCH, MATCH combination to achieve this task. Follow these steps:
- Fill in the P&L Statement: Utilize the data from Bloomberg to populate your P&L, including all relevant revenue and expense lines;
- Calculate Profitability Margins;
- Gross Profit Margin: Calculate Gross Profit and then divide the result by Revenue;
- EBIT Margin: Calculate EBIT and divide this value by Revenue;
- Add New Rows: Integrate these calculations into the P&L structure by adding new rows beneath the Gross Profit and EBIT sections;
- CAGR Calculation: Finally, compute the Compound Annual Growth Rate (CAGR) for Revenue, Gross Profit, and EBIT. Ensure your calculations reflect the specific period under analysis.
